SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspCity_INSERT
(
@cityId AS int = null,
@regionId AS int = null,
@name AS nvarchar(128) = null,
@isVisible AS bit = null
)
AS

INSERT INTO
  [dbo].[City]
(
  [CityId],
  [RegionId],
  [Name],
  [IsVisible]
)
VALUES
(
  @cityId,
  @regionId,
  @name,
  @isVisible
)

SELECT SCOPE_IDENTITY()


GO
